{
  "statement": "select /*+ set_var(new_planner_optimize_timeout = 10000) */ 1 as relation_key ,\n\t\tsum(ads_sp_cost) as ads_sp_cost ,\n\t\tsum(shared_ads_sb_cost) as shared_ads_sb_cost ,\n\t\tsum(shared_ads_sbv_cost) as shared_ads_sbv_cost ,\n\t\tsum(ads_sd_cost) as ads_sd_cost ,\n\t\tsum(shared_cost_of_advertising) as shared_cost_of_advertising ,\n\t\tsum(spend) as spend ,\n\t\tsum(gross_profit) as gross_profit ,\n\t\tsum(df_amount) as df_amount\n\tfrom\n\t\t(\n\t\tselect\n\t\t\tads_sp_cost ,\n\t\t\tshared_ads_sb_cost ,\n\t\t\tshared_ads_sbv_cost ,\n\t\t\tads_sd_cost ,\n\t\t\tshared_cost_of_advertising ,\n\t\t\tspend ,\n\t\t\tgross_profit ,\n\t\t\tdf_amount ,\n\t\t\tunnest as principal_uids\n\t\tfrom\n\t\t\t(\n\t\t\tselect\n\t\t\t\tcoalesce(dpr.principal_uids, '-1') as principal_uids ,\n\t\t\t\tsum(coalesce(t.ads_sp_cost, 0) * m_cny_rate.rate / m_target_rate.rate) as ads_sp_cost ,\n\t\t\t\tsum(coalesce(t.shared_ads_sb_cost, 0) * m_cny_rate.rate / m_target_rate.rate) as shared_ads_sb_cost ,\n\t\t\t\tsum(coalesce(t.shared_ads_sbv_cost, 0) * m_cny_rate.rate / m_target_rate.rate) as shared_ads_sbv_cost ,\n\t\t\t\tsum(coalesce(t.ads_sd_cost, 0) * m_cny_rate.rate / m_target_rate.rate) as ads_sd_cost ,\n\t\t\t\tsum(coalesce(t.shared_cost_of_advertising, 0) * m_cny_rate.rate / m_target_rate.rate) as shared_cost_of_advertising ,\n\t\t\t\t0 as spend ,\n\t\t\t\tsum(( coalesce(t.total_sales_amount, 0) + coalesce(t.shipping_credits, 0) + coalesce(t.promotional_rebates, 0) + coalesce(t.fba_inventory_credit, 0) + coalesce(t.cash_on_delivery, 0) + coalesce(t.other_in_amount, 0) ) * coalesce(m_cny_rate.rate, 1) / coalesce(m_target_rate.rate, 1)) as df_amount ,\n\t\t\t\tsum((coalesce(t.total_sales_amount, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.shipping_credits, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.promotional_rebates, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.fba_inventory_credit, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.cash_on_delivery, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.other_in_amount, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.total_sales_refunds, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.total_fee_refunds, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.platform_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.fba_delivery_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.other_transaction_fees, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.total_spend, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.promotion_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.total_storage_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.shared_fba_integerernational_inbound_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.total_platform_other_fee, 0) * coalesce(m_cny_rate.rate, 1) + coalesce(t.adjustments, 0) * coalesce(m_cny_rate.rate, 1) - coalesce(dpr.cg_price * t.cg_price_quantity, 0) * coalesce(m_cg_price_cny_rate.rate, 1) - coalesce(dpr.cg_transport_costs * t.cg_transport_costs_quantity, 0) * coalesce(m_cg_transport_costs_cny_rate.rate, 1) ) / coalesce(m_target_rate.rate, 1)) as gross_profit\n\t\t\tfrom\n\t\t\t\t(\n\t\t\t\tselect\n\t\t\t\t\tt.posted_date_locale as r_date ,\n\t\t\t\t\tdsr.zid ,\n\t\t\t\t\tdsr.sid ,\n\t\t\t\t\tt.seller_sku ,\n\t\t\t\t\tcoalesce(shared_ads_sb_cost, 0) + coalesce(shared_ads_sbv_cost, 0) + coalesce(ads_sd_cost, 0) + coalesce(ads_sp_cost, 0) as total_spend ,\n\t\t\t\t\tnull as shared_cost_of_advertising ,\n\t\t\t\t\tcoalesce(ads_sd_cost, 0) + coalesce(ads_sp_cost, 0) as new_ad_total_spend ,\n\t\t\t\t\tcoalesce(shared_ads_sb_cost, 0) as shared_ads_sb_cost ,\n\t\t\t\t\tcoalesce(shared_ads_sbv_cost, 0) as shared_ads_sbv_cost ,\n\t\t\t\t\tcoalesce(ads_sd_cost, 0) as ads_sd_cost ,\n\t\t\t\t\tcoalesce(ads_sp_cost, 0) as ads_sp_cost ,\n\t\t\t\t\t( coalesce(other_fba_product_sales, 0) + coalesce(principal_fba_product_sales, 0) + coalesce(reship_fba_product_sales, 0) + coalesce(shared_other_fba_product_sales, 0) + coalesce(other_fbm_product_sales, 0) + coalesce(principal_fbm_product_sales, 0) + coalesce(reship_fbm_product_sales, 0) + coalesce(gift_wrap_credits, 0) + coalesce(a_to_z_guarantee_claims, 0) + coalesce(cost_of_points_granted, 0) ) as total_sales_amount ,\n\t\t\t\t\tcoalesce(shipping_credits, 0) as shipping_credits ,\n\t\t\t\t\t(coalesce(promotional_rebates, 0) + + coalesce(shared_promotional_rebates, 0)) as promotional_rebates ,\n\t\t\t\t\t( coalesce(fba_inventory_credit, 0) + coalesce(shared_fba_inventory_credit, 0) ) as fba_inventory_credit ,\n\t\t\t\t\tcoalesce(shared_cash_on_delivery, 0) as cash_on_delivery ,\n\t\t\t\t\t( coalesce(shared_fba_liquidation_proceeds, 0) + coalesce(shared_amazon_shipping_reimbursement, 0) + coalesce(shared_safe_t_reimbursement, 0) + coalesce(shared_netco_transaction, 0) + coalesce(shared_reimbursements, 0) + coalesce(shared_clawbacks, 0) + coalesce(shared_others, 0) + coalesce(shared_fba_liquidation_proceeds_adjustments, 0) + coalesce(shared_commingling_vat_income, 0) ) as other_in_amount ,\n\t\t\t\t\t( coalesce(other_fba_product_sale_refunds, 0) + coalesce(principal_fba_product_sale_refunds, 0) + coalesce(reship_fba_product_sale_refunds, 0) + coalesce(other_fbm_product_sale_refunds, 0) + coalesce(principal_fbm_product_sale_refunds, 0) + coalesce(reship_fbm_product_sale_refunds, 0) + coalesce(shipping_credit_refunds, 0) + coalesce(gift_wrap_credit_refunds, 0) + coalesce(chargebacks, 0) + coalesce(cost_of_points_returned, 0) + coalesce(promotional_rebate_refunds, 0) + coalesce(shared_promotional_rebate_refunds, 0) ) as total_sales_refunds ,\n\t\t\t\t\t( coalesce(selling_fee_refunds, 0) + coalesce(fba_transaction_fee_refunds, 0) + coalesce(shared_fba_transaction_fee_refunds, 0) + coalesce(refund_administration_fees, 0) + coalesce(other_transaction_fee_refunds, 0) + coalesce(shared_refund_for_advertiser, 0) + coalesce(points_adjusted, 0) + coalesce(shipping_label_refunds, 0) + coalesce(shared_shipping_label_refunds, 0) ) as total_fee_refunds ,\n\t\t\t\t\t( coalesce(seller_fulfilled_selling_fees, 0) + coalesce(fba_selling_fees, 0) ) as platform_fee ,\n\t\t\t\t\t( coalesce(other_fba_transaction_fees, 0) + coalesce(mc_fba_fulfillment_fees, 0) + coalesce(shared_other_fba_transaction_fees, 0) ) as fba_delivery_fee ,\n\t\t\t\t\t(coalesce(other_transaction_fees, 0) + coalesce(shared_other_transaction_fees, 0)) as other_transaction_fees ,\n\t\t\t\t\t( coalesce(shared_subscription_fee, 0) + coalesce(shared_ld_fee, 0) + coalesce(shared_coupon_fee, 0) + coalesce(shared_early_reviewer_program_fee, 0) + coalesce(shared_vine_fee, 0) ) as promotion_fee ,\n\t\t\t\t\t( coalesce(fba_storage_fee, 0) + coalesce(shared_fba_storage_fee, 0) + coalesce(long_term_storage_fee, 0) + coalesce(shared_long_term_storage_fee, 0) + coalesce(shared_storage_renewal_billing, 0) + coalesce(shared_fba_disposal_fee, 0) + coalesce(shared_fba_removal_fee, 0) + coalesce(shared_fba_inbound_transportation_program_fee, 0) + coalesce(shared_labeling_fee, 0) + coalesce(shared_polybagging_fee, 0) + coalesce(shared_bubblewrap_fee, 0) + coalesce(shared_taping_fee, 0) + coalesce(shared_fba_customer_return_fee, 0) + coalesce(fba_customer_return_fee, 0) + coalesce(shared_fba_inbound_defect_fee, 0) + coalesce(shared_fba_overage_fee, 0) + coalesce(shared_amazon_partnered_carrier_shipment_fee, 0) + coalesce(shared_fba_inbound_convenience_fee, 0) + coalesce(shared_item_fee_adjustment, 0) + coalesce(shared_other_fba_inventory_fees, 0) ) as total_storage_fee ,\n\t\t\t\t\tcoalesce(shared_fba_international_inbound_fee, 0) as shared_fba_integerernational_inbound_fee ,\n\t\t\t\t\t( coalesce(shipping_label_purchases, 0) + coalesce(shared_shipping_label_purchases, 0) + coalesce(shared_carrier_shipping_label_adjustments, 0) + coalesce(shared_liquidations_fees, 0) + coalesce(shared_manual_processing_fee, 0) + coalesce(shared_other_service_fees, 0) ) as total_platform_other_fee ,\n\t\t\t\t\t( coalesce(adjustments, 0) + coalesce(shared_adjustments, 0) ) as adjustments ,\n\t\t\t\t\t(coalesce(principal_fbm_product_sales_quantity, 0) + coalesce(principal_fba_product_sales_quantity, 0) + coalesce(reship_fbm_product_sales_quantity, 0) + coalesce(reship_fba_product_sales_quantity, 0) + coalesce(mc_fba_fulfillment_fees_quantity, 0) - coalesce(fba_returns_quantity, 0) ) AS cg_price_quantity ,\n\t\t\t\t\t(coalesce(principal_fbm_product_sales_quantity, 0) + coalesce(principal_fba_product_sales_quantity, 0) + coalesce(reship_fbm_product_sales_quantity, 0) + coalesce(reship_fba_product_sales_quantity, 0) + coalesce(mc_fba_fulfillment_fees_quantity, 0) - coalesce(fba_returns_quantity, 0) ) AS cg_transport_costs_quantity\n\t\t\t\tfrom\n\t\t\t\t\t(\n\t\t\t\t\tselect\n\t\t\t\t\t\ta.* ,\n\t\t\t\t\t\tget_json_double(a.`__extend_fields`,\n\t\t\t\t\t\t'$.shared_other_transaction_fees') as shared_other_transaction_fees ,\n\t\t\t\t\t\tget_json_double(a.`__extend_fields`,\n\t\t\t\t\t\t'$.shared_shipping_label_refunds') as shared_shipping_label_refunds ,\n\t\t\t\t\t\tget_json_double(a.`__extend_fields`,\n\t\t\t\t\t\t'$.shared_promotional_rebates') as shared_promotional_rebates ,\n\t\t\t\t\t\tget_json_double(a.`__extend_fields`,\n\t\t\t\t\t\t'$.shared_promotional_rebate_refunds') as shared_promotional_rebate_refunds\n\t\t\t\t\tfrom\n\t\t\t\t\t\t(\n\t\t\t\t\t\tselect\n\t\t\t\t\t\t\t* ,\n\t\t\t\t\t\t\trow_number() over(partition by company_id,\n\t\t\t\t\t\t\tseller_id,\n\t\t\t\t\t\t\tcountry_code,\n\t\t\t\t\t\t\tseller_sku,\n\t\t\t\t\t\t\tposted_date_locale\n\t\t\t\t\t\torder by\n\t\t\t\t\t\t\tid desc) rn\n\t\t\t\t\t\tfrom\n\t\t\t\t\t\t\tdaily_profit_statis_v4 t\n\t\t\t\t\t\twhere\n\t\t\t\t\t\t\tcompany_id = 901117781768839168\n\t\t\t\t\t\t\tand t.posted_date_locale >= '2022-08-01'\n\t\t\t\t\t\t\tand t.posted_date_locale <= '2022-08-31' ) a\n\t\t\t\t\twhere\n\t\t\t\t\t\trn = 1 ) t\n\t\t\t\tinner join dim_seller_rf dsr on\n\t\t\t\t\tt.seller_id = dsr.seller_id\n\t\t\t\t\tand t.country_code = dsr.code\n\t\t\t\t\tand t.company_id = dsr.company_id\n\t\t\t\twhere\n\t\t\t\t\tdsr.zid = 1 ) t\n\t\t\tinner join (\n\t\t\t\tselect\n\t\t\t\t\tt.zid ,\n\t\t\t\t\tt.sid ,\n\t\t\t\t\tt.asin ,\n\t\t\t\t\tt.seller_sku ,\n\t\t\t\t\tt.parent_asin ,\n\t\t\t\t\tt.local_sku ,\n\t\t\t\t\tt.cg_price ,\n\t\t\t\t\tif(length(t.cg_price_currency_code) > 0,\n\t\t\t\t\tt.cg_price_currency_code,\n\t\t\t\t\t'CNY') as cg_price_currency_code ,\n\t\t\t\t\tt.cg_transport_costs ,\n\t\t\t\t\tif(length(t.cg_transport_costs_currency_code) >0,\n\t\t\t\t\tt.cg_transport_costs_currency_code,\n\t\t\t\t\t'CNY') as cg_transport_costs_currency_code ,\n\t\t\t\t\ts.seller_id ,\n\t\t\t\t\ts.code as country_code ,\n\t\t\t\t\ts.currency_code ,\n\t\t\t\t\ts.currency_icon ,\n\t\t\t\t\ts.mid ,\n\t\t\t\t\tt.company_id ,\n\t\t\t\t\tt.principal_uids\n\t\t\t\tfrom\n\t\t\t\t\tdim_product_rf t\n\t\t\t\tinner join (\n\t\t\t\t\tselect\n\t\t\t\t\t\t*\n\t\t\t\t\tfrom\n\t\t\t\t\t\tdim_seller_rf t\n\t\t\t\t\twhere\n\t\t\t\t\t\tt.zid = 1 ) s on\n\t\t\t\t\tt.zid = s.zid\n\t\t\t\t\tand t.sid = s.sid\n\t\t\t\twhere\n\t\t\t\t\tt.zid = 1\n\t\t\t\t\tand t.company_id = 901117781768839168\n\t\t\t\t\tand t.is_parent != 1\n\t\t\t\t\t) dpr on\n\t\t\t\tdpr.zid = t.zid\n\t\t\t\tand dpr.sid = t.sid\n\t\t\t\tand dpr.seller_sku = t.seller_sku\n\t\t\tleft join (\n\t\t\t\tselect\n\t\t\t\t\tzid,\n\t\t\t\t\tcode,\n\t\t\t\t\ticon,\n\t\t\t\t\trate,\n\t\t\t\t\tdate\n\t\t\t\tfrom\n\t\t\t\t\tcompany_currency_month\n\t\t\t\twhere\n\t\t\t\t\tzid = 1\n\t\t\t\t\tand date between substring( '2022-08-01' , 1, 7) and substring( '2022-08-31' , 1, 7) ) m_cny_rate on\n\t\t\t\tdpr.zid = m_cny_rate.zid\n\t\t\t\tand dpr.currency_code = m_cny_rate.code\n\t\t\t\tand substring(t.r_date, 1, 7)= m_cny_rate.date\n\t\t\tleft join (\n\t\t\t\tselect\n\t\t\t\t\tzid,\n\t\t\t\t\tcode,\n\t\t\t\t\ticon,\n\t\t\t\t\trate,\n\t\t\t\t\tdate\n\t\t\t\tfrom\n\t\t\t\t\tcompany_currency_month\n\t\t\t\twhere\n\t\t\t\t\tzid = 1\n\t\t\t\t\tand date between substring( '2022-08-01' , 1, 7) and substring( '2022-08-31' , 1, 7) ) m_cg_price_cny_rate on\n\t\t\t\tdpr.zid = m_cny_rate.zid\n\t\t\t\tand dpr.cg_price_currency_code = m_cny_rate.code\n\t\t\t\tand substring(t.r_date, 1, 7)= m_cny_rate.date\n\t\t\tleft join (\n\t\t\t\tselect\n\t\t\t\t\tzid ,\n\t\t\t\t\tcode ,\n\t\t\t\t\ticon ,\n\t\t\t\t\trate ,\n\t\t\t\t\tdate\n\t\t\t\tfrom\n\t\t\t\t\tcompany_currency_month\n\t\t\t\twhere\n\t\t\t\t\tzid = 1\n\t\t\t\t\tand date between substring( '2022-08-01' , 1, 7) and substring( '2022-08-31' , 1, 7) ) m_cg_transport_costs_cny_rate on\n\t\t\t\tdpr.zid = m_cg_transport_costs_cny_rate.zid\n\t\t\t\tand dpr.cg_transport_costs_currency_code = m_cg_transport_costs_cny_rate.code\n\t\t\t\tand substring(t.r_date, 1, 7) = m_cg_transport_costs_cny_rate.date\n\t\t\tleft join (\n\t\t\t\tselect\n\t\t\t\t\tzid,\n\t\t\t\t\tcode,\n\t\t\t\t\ticon,\n\t\t\t\t\trate,\n\t\t\t\t\tdate\n\t\t\t\tfrom\n\t\t\t\t\tcompany_currency_month\n\t\t\t\twhere\n\t\t\t\t\tzid = 1\n\t\t\t\t\tand date between substring( '2022-08-01' , 1, 7) and substring( '2022-08-31' , 1, 7)\n\t\t\t\t\t\tand code = 'USD' ) m_target_rate on\n\t\t\t\tdpr.zid = m_cny_rate.zid\n\t\t\t\tand substring(t.r_date, 1, 7)= m_target_rate.date\n\t\t\tgroup by\n\t\t\t\tdpr.principal_uids ) a ,\n\t\t\tunnest(split(principal_uids,\n\t\t\t',')) ) a;\n",
  "table_meta": {
    "data_masking.company_currency_month": "CREATE TABLE `company_currency_month` (\n  `id` bigint(20) NOT NULL COMMENT \"\",\n  `zid` int(11) NOT NULL COMMENT \"ID\",\n  `code` varchar(65533) NULL COMMENT \"code\",\n  `icon` varchar(65533) NULL COMMENT \"（：￥）\",\n  `name` varchar(65533) NULL COMMENT \"（：）\",\n  `rate` decimal128(18, 10) NULL DEFAULT \"0.0000\" COMMENT \"\",\n  `official_rate` decimal128(19, 6) NULL COMMENT \"\",\n  `sort` int(11) NULL DEFAULT \"99\" COMMENT \"99，1，\",\n  `update_uid` int(11) NULL DEFAULT \"0\" COMMENT \"UID\",\n  `is_update` int(11) NULL DEFAULT \"0\" COMMENT \"python\",\n  `date` varchar(65533) NULL COMMENT \"\",\n  `gmt_modified` datetime NULL COMMENT \"\",\n  `gmt_create` datetime NULL COMMENT \"\",\n  `update_time` varchar(65533) NULL COMMENT \"\",\n  `rate_long` decimal64(18, 10) NULL DEFAULT \"0.0000000000\" COMMENT \"(10)\",\n  `official_rate_long` decimal64(18, 10) NULL DEFAULT \"0.0000000000\" COMMENT \"(10)\",\n  `company_id` bigint(20) NULL DEFAULT \"0\" COMMENT \"id\",\n  `v_uuid` varchar(120) NULL DEFAULT \"\" COMMENT \"BGID，\"\n) ENGINE=OLAP \nPRIMARY KEY(`id`)\nCOMMENT \"【】\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "data_masking.daily_profit_statis_v4": "CREATE TABLE `daily_profit_statis_v4` (\n  `company_id` bigint(20) NOT NULL COMMENT \"\",\n  `pg_instance` bigint(20) NOT NULL COMMENT \"\",\n  `id` bigint(20) NOT NULL COMMENT \"\",\n  `posted_date_locale` date NULL COMMENT \"\",\n  `seller_id` varchar(300) NULL COMMENT \"\",\n  `country_code` varchar(300) NULL COMMENT \"\",\n  `seller_sku` varchar(300) NULL COMMENT \"\",\n  `asin` varchar(300) NULL COMMENT \"\",\n  `other_fbm_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fbm_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fbm_product_sales_quantity` bigint(20) NULL COMMENT \"\",\n  `reship_fbm_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `reship_fbm_product_sales_quantity` bigint(20) NULL COMMENT \"\",\n  `other_fbm_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fbm_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fbm_product_sale_refunds_quantity` bigint(20) NULL COMMENT \"\",\n  `reship_fbm_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `reship_fbm_product_sale_refunds_quantity` bigint(20) NULL COMMENT \"\",\n  `other_fba_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_other_fba_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_shipping_label_purchases` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fba_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fba_product_sales_quantity` bigint(20) NULL COMMENT \"\",\n  `reship_fba_product_sales` decimal64(16, 6) NULL COMMENT \"\",\n  `reship_fba_product_sales_quantity` bigint(20) NULL COMMENT \"\",\n  `other_fba_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fba_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `principal_fba_product_sale_refunds_quantity` bigint(20) NULL COMMENT \"\",\n  `reship_fba_product_sale_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `reship_fba_product_sale_refunds_quantity` bigint(20) NULL COMMENT \"\",\n  `fba_inventory_credit` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_liquidation_proceeds` decimal64(16, 6) NULL COMMENT \"\",\n  `shipping_credits` decimal64(16, 6) NULL COMMENT \"\",\n  `shipping_credit_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `gift_wrap_credits` decimal64(16, 6) NULL COMMENT \"\",\n  `gift_wrap_credit_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `promotional_rebates` decimal64(16, 6) NULL COMMENT \"\",\n  `promotional_rebate_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `a_to_z_guarantee_claims` decimal64(16, 6) NULL COMMENT \"\",\n  `chargebacks` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_amazon_shipping_reimbursement` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_safe_t_reimbursement` decimal64(16, 6) NULL COMMENT \"\",\n  `cost_of_points_granted` decimal64(16, 6) NULL COMMENT \"\",\n  `cost_of_points_returned` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_netco_transaction` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_reimbursements` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_clawbacks` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_others` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_cash_on_delivery` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_liquidation_proceeds_adjustments` decimal64(16, 6) NULL COMMENT \"\",\n  `seller_fulfilled_selling_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `fba_selling_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `selling_fee_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `other_fba_transaction_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `mc_fba_fulfillment_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `mc_fba_fulfillment_fees_quantity` bigint(20) NULL COMMENT \"\",\n  `fba_transaction_fee_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `other_transaction_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `other_transaction_fee_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_other_fba_inventory_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_storage_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_long_term_storage_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_storage_renewal_billing` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_disposal_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_removal_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_inbound_transportation_program_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_labeling_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_polybagging_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_customer_return_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_inbound_defect_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_item_fee_adjustment` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_amazon_partnered_carrier_shipment_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_inbound_convenience_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_overage_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_bubblewrap_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_taping_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shipping_label_purchases` decimal64(16, 6) NULL COMMENT \"\",\n  `shipping_label_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_carrier_shipping_label_adjustments` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_other_service_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_international_inbound_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_subscription_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_ld_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_coupon_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_early_reviewer_program_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_manual_processing_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `refund_administration_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_adjustments` decimal64(16, 6) NULL COMMENT \"\",\n  `points_adjusted` decimal64(16, 6) NULL COMMENT \"\",\n  `ads_sp_cost` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_ads_sb_cost` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_ads_sbv_cost` decimal64(16, 6) NULL COMMENT \"\",\n  `ads_sd_cost` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_cost_of_advertising` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_refund_for_advertiser` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_liquidations_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_igst_collected` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_igst_refunded` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_sgst_collected` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_sgst_refunded` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_cgst_collected` decimal64(16, 6) NULL COMMENT \"\",\n  `tcs_cgst_refunded` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_commingling_vat_expenses` decimal64(16, 6) NULL COMMENT \"\",\n  `tax_collected` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_tax_collected` decimal64(16, 6) NULL COMMENT \"\",\n  `tax_refunded` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_tax_refunded` decimal64(16, 6) NULL COMMENT \"\",\n  `sales_tax_withheld` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_sales_tax_withheld` decimal64(16, 6) NULL COMMENT \"\",\n  `refund_tax_withheld` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_refund_tax_withheld` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_income_tax_withheld` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_tds_section_194_o_net` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_transfers_to_bank_account` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_failed_transfers_to_bank_account` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_charges_to_credit_card` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_disburse_to_amazon_gift_card_balance` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_amazon_lending_debits` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_amazon_lending_credits` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_fba_transaction_fee_refunds` decimal64(16, 6) NULL COMMENT \"\",\n  `adjustments` decimal64(16, 6) NULL COMMENT \"\",\n  `fba_storage_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `long_term_storage_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_vine_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `cg_price` decimal64(16, 6) NULL COMMENT \"\",\n  `cg_transport_costs` decimal64(16, 6) NULL COMMENT \"\",\n  `cg_transport_costs_currency_code` varchar(300) NULL COMMENT \"\",\n  `small_image_url` varchar(1000) NULL COMMENT \"\",\n  `item_name` varchar(1500) NULL COMMENT \"\",\n  `shared_fba_inventory_credit` decimal64(16, 6) NULL COMMENT \"\",\n  `fba_customer_return_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `shared_other_fba_transaction_fees` decimal64(16, 6) NULL COMMENT \"\",\n  `gmt_modified` datetime NULL COMMENT \"\",\n  `gmt_create` datetime NULL COMMENT \"\",\n  `cost_center_purchase_costs_total` decimal64(16, 6) NULL COMMENT \"\",\n  `cost_center_purchase_costs_detail` varchar(65533) NULL COMMENT \"\",\n  `cost_center_logistics_costs_total` decimal64(16, 6) NULL COMMENT \"\",\n  `cost_center_logistics_costs_detail` varchar(65533) NULL COMMENT \"\",\n  `cost_center_other_costs_total` decimal64(16, 6) NULL COMMENT \"\",\n  `cost_center_other_costs_detail` varchar(65533) NULL COMMENT \"\",\n  `cost_center_quantity` bigint(20) NULL COMMENT \"\",\n  `cost_center_currency_code` varchar(50) NULL COMMENT \"\",\n  `shared_commingling_vat_income` decimal64(16, 6) NULL COMMENT \"\",\n  `fba_returns_quantity` bigint(20) NULL COMMENT \"\",\n  `fba_returns_unsaleable_quantity` bigint(20) NULL COMMENT \"\",\n  `custom_order_fee` decimal64(16, 6) NULL COMMENT \"\",\n  `__extend_fields` varchar(65535) NULL COMMENT \"\"\n) ENGINE=OLAP \nPRIMARY KEY(`company_id`, `pg_instance`, `id`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`pg_instance`)\n(PARTITION p1 VALUES [(\"1\"), (\"2\")),\nPARTITION p2 VALUES [(\"2\"), (\"3\")),\nPARTITION p3 VALUES [(\"3\"), (\"4\")),\nPARTITION p4 VALUES [(\"4\"), (\"5\")),\nPARTITION p5 VALUES [(\"5\"), (\"6\")),\nPARTITION p6 VALUES [(\"6\"), (\"7\")),\nPARTITION p7 VALUES [(\"7\"), (\"8\")),\nPARTITION p8 VALUES [(\"8\"), (\"9\")),\nPARTITION p9 VALUES [(\"9\"), (\"10\")))\nDISTRIBUTED BY HASH(`company_id`, `pg_instance`, `id`) BUCKETS 10 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "data_masking.dim_product_rf": "CREATE TABLE `dim_product_rf` (\n  `zid` int(11) NULL COMMENT \"ID\",\n  `sid` int(11) NULL COMMENT \"ID\",\n  `seller_sku` varchar(150) NULL COMMENT \"sku\",\n  `parent_asin` varchar(60) NULL COMMENT \"is_parent=1，parent_asin=asin1\",\n  `asin` varchar(60) NULL COMMENT \"asin\",\n  `pid` int(11) NULL COMMENT \"ID\",\n  `bid` int(11) NULL COMMENT \"id\",\n  `cid` int(11) NULL COMMENT \"id\",\n  `product_mws_id` bigint(20) NULL COMMENT \"ID,\",\n  `cate_title` varchar(1500) NULL COMMENT \"\",\n  `local_sku` varchar(150) NULL COMMENT \"sku\",\n  `local_name` varchar(1500) NULL COMMENT \"\",\n  `item_name` varchar(1500) NULL COMMENT \"\",\n  `listing_id` varchar(90) NULL COMMENT \"listingid\",\n  `listing_price` varchar(30) NULL COMMENT \"listing\",\n  `price` decimal64(18, 6) NULL COMMENT \"\",\n  `cg_price` decimal64(18, 6) NULL COMMENT \"(CNY)\",\n  `image_url` varchar(900) NULL COMMENT \"\",\n  `item_is_marketplace` varchar(30) NULL COMMENT \"\",\n  `status` int(11) NULL COMMENT \"：-1=，1=active，0=inactive，2=incomplete\",\n  `small_image_url` varchar(900) NULL COMMENT \"\",\n  `fnsku` varchar(150) NULL COMMENT \"FBAsku\",\n  `open_date` varchar(120) NULL COMMENT \"\",\n  `listing_update_date` varchar(90) NULL COMMENT \"listing\",\n  `fulfillment_channel` varchar(150) NULL COMMENT \"\",\n  `gmt_modified` datetime NULL COMMENT \"\",\n  `product_developer` varchar(900) NULL COMMENT \"\",\n  `product_developer_uid` int(11) NULL COMMENT \"id\",\n  `product_designer` varchar(150) NULL COMMENT \"\",\n  `product_presenter` varchar(150) NULL COMMENT \"\",\n  `model` varchar(300) NULL COMMENT \"\",\n  `product_pic_url` varchar(900) NULL COMMENT \"\",\n  `product_status` int(11) NULL COMMENT \"：0- 1- 2- 3-\",\n  `realnames` varchar(1000) NULL COMMENT \",\",\n  `brand_title` varchar(100) NULL COMMENT \"\",\n  `landed_price` varchar(90) NULL COMMENT \"\",\n  `open_date_time` int(11) NULL COMMENT \"，\",\n  `listing_create_date` varchar(90) NULL COMMENT \"listing，\",\n  `is_delete` int(11) NULL COMMENT \"\",\n  `principal_uids` varchar(200) NULL COMMENT \"id,\",\n  `regular_price` decimal64(16, 6) NULL COMMENT \"（、、）\",\n  `regular_price_currency_code` varchar(100) NULL COMMENT \"\",\n  `is_pd` int(11) NULL COMMENT \"product，，ETL\",\n  `is_member` int(11) NULL COMMENT \"member，，ETL\",\n  `is_parent` int(11) NULL COMMENT \"asin,1=；0=asin\",\n  `cg_price_currency_code` varchar(50) NULL COMMENT \"\",\n  `cg_transport_costs` decimal64(18, 6) NULL COMMENT \"\",\n  `cg_transport_costs_currency_code` varchar(50) NULL COMMENT \"\",\n  `company_id` bigint(20) NULL DEFAULT \"0\" COMMENT \"\",\n  `attribute` varchar(65535) NULL COMMENT \"\",\n  `ps_id` int(11) NULL COMMENT \"spuid\",\n  `spu` varchar(65535) NULL COMMENT \"\",\n  `spu_name` varchar(65535) NULL COMMENT \"\",\n  `product_create_time` int(11) NULL DEFAULT \"0\" COMMENT \"productcreate_time\"\n) ENGINE=OLAP \nUNIQUE KEY(`zid`, `sid`, `seller_sku`)\nCOMMENT \"\"\nDISTRIBUTED BY HASH(`zid`, `sid`, `seller_sku`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"V2\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "data_masking.dim_seller_rf": "CREATE TABLE `dim_seller_rf` (\n  `zid` int(11) NULL COMMENT \"ID\",\n  `sid` int(11) NULL COMMENT \"ID\",\n  `currency_code` char(15) NULL COMMENT \"\",\n  `mid` int(11) NULL COMMENT \"【mws_marketplace】ID\",\n  `seller_account_id` int(11) NULL COMMENT \"seller_account\",\n  `name` varchar(150) NULL COMMENT \"\",\n  `seller_account_name` varchar(150) NULL COMMENT \"（，seller_accountseller_account_name）\",\n  `seller_id` varchar(90) NULL COMMENT \"（MERCHANT_ID）\",\n  `mws_auth_token` varchar(150) NULL COMMENT \"TOKEN\",\n  `seller_status` smallint(6) NULL COMMENT \"：-1=，1=，2=，0=，3\",\n  `seller_sort` int(11) NULL COMMENT \"\",\n  `gmt_modified` datetime NULL COMMENT \"\",\n  `gmt_create` datetime NULL COMMENT \"\",\n  `sp_refresh_token` varchar(996) NULL COMMENT \"sp api token\",\n  `region` char(6) NULL COMMENT \"：na=，eu=\",\n  `country` varchar(72) NULL COMMENT \"\",\n  `code` char(12) NULL COMMENT \"：CA、US、DE\",\n  `mws_url` varchar(64) NULL COMMENT \" MWS \",\n  `site_url` varchar(765) NULL COMMENT \"：https:// www.amazon.com\",\n  `marketplace_id` char(48) NULL COMMENT \"MarketplaceId\",\n  `marketplace_id_sandbox` char(48) NULL COMMENT \"MarketplaceId，Non-Amazon，get_order\",\n  `timezone_name` varchar(60) NULL COMMENT \"：\",\n  `timezone` varchar(60) NULL COMMENT \"\",\n  `sales_channel` varchar(60) NULL COMMENT \"：\",\n  `marketplace_sort` int(11) NULL COMMENT \"\",\n  `marketplace_status` int(11) NULL COMMENT \"：0，1\",\n  `currency_icon` varchar(200) NULL COMMENT \"（：￥）\",\n  `currency_name` varchar(500) NULL COMMENT \"（：）\",\n  `rate` decimal64(10, 4) NULL DEFAULT \"0.0000\" COMMENT \"\",\n  `is_eur` int(11) NULL COMMENT \"，1：，\",\n  `first_eur` int(11) NULL COMMENT \"，1：，\",\n  `company_id` bigint(20) NULL DEFAULT \"0\" COMMENT \"\"\n) ENGINE=OLAP \nUNIQUE KEY(`zid`, `sid`, `currency_code`)\nCOMMENT \"\"\nDISTRIBUTED BY HASH(`zid`, `sid`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"V2\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);"
  },
  "table_row_count": {
    "data_masking.company_currency_month": {
      "company_currency_month": 1921
    },
    "data_masking.dim_seller_rf": {
      "dim_seller_rf": 27
    },
    "data_masking.dim_product_rf": {
      "dim_product_rf": 6156
    },
    "data_masking.daily_profit_statis_v4": {
      "p1": 2910
    }
  },
  "session_variables": "{\"enable_show_all_variables\":false,\"cbo_cte_reuse\":false,\"full_sort_max_buffered_bytes\":16777216,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"enable_query_tablet_affinity\":false,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":false,\"enable_resource_group_v2\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":3000,\"enable_realtime_mv\":false,\"enable_adaptive_sink_dop\":false,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":1,\"select_ratio_threshold\":0.15,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"exec_mem_limit\":17179869184,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"full_sort_max_buffered_rows\":1024000,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":259200,\"connector_io_tasks_slow_io_latency_ms\":50,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"enable_distinct_column_bucketization\":false,\"interpolate_passthrough\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"enable_strict_type\":false,\"broadcast_right_table_scale_factor\":10,\"group_concat_max_len\":65535,\"disable_streaming_preaggregations\":false,\"enable_simplify_case_when\":true,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":false,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"hdfs_backend_selector_scan_range_shuffle\":false,\"enable_column_expr_predicate\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":8,\"max_scan_key_num\":-1,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":5000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"max_allowed_packet\":15728640,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics": {
    "data_masking.company_currency_month": {
      "date": "[-Infinity, Infinity, 0.0, 7.0, 113.0] ESTIMATE",
      "code": "[-Infinity, Infinity, 0.0, 3.0, 17.0] ESTIMATE",
      "zid": "[1.0, 1.0, 0.0, 4.0, 1.0] ESTIMATE",
      "rate": "[0.0563, 10.0, 0.0, 16.0, 33.0] ESTIMATE"
    },
    "data_masking.dim_seller_rf": {
      "code": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "company_id": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "zid": "[1.0, 1.0, 0.0, 4.0, 1.0] ESTIMATE",
      "seller_id": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "currency_code": "[-Infinity, Infinity, 0.0, 3.0, 17.0] ESTIMATE",
      "sid": "[1.0, 15.0, 0.4444444444444444, 4.0, 15.0] ESTIMATE"
    },
    "data_masking.dim_product_rf": {
      "cg_price_currency_code": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "cg_transport_costs": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "principal_uids": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "company_id": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "zid": "[1.0, 1.0, 1.6244314489928524E-4, 4.0, 1.0] ESTIMATE",
      "cg_transport_costs_currency_code": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "seller_sku": "[-Infinity, Infinity, 1.6244314489928524E-4, 31.958739441195583, 5110.0] ESTIMATE",
      "cg_price": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "is_parent": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sid": "[1.0, 15.0, 1.6244314489928524E-4, 4.0, 15.0] ESTIMATE"
    },
    "data_masking.daily_profit_statis_v4": {
      "shared_refund_for_advertiser": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "fba_selling_fees": "[-20969.0, 0.0, 0.0, 8.0, 3470.0] ESTIMATE",
      "refund_administration_fees": "[-83.0, 0.0, 0.0, 8.0, 174.0] ESTIMATE",
      "reship_fbm_product_sales_quantity": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_removal_fee": "[-26.19, 0.0, 0.0, 8.0, 28.0] ESTIMATE",
      "shared_polybagging_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "principal_fba_product_sales_quantity": "[0.0, 218.0, 0.0, 8.0, 94.0] ESTIMATE",
      "other_fba_product_sales": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_disposal_fee": "[-10606.86, 0.0, 0.0, 8.0, 478.0] ESTIMATE",
      "posted_date_locale": "[1.6094304E9, 1.675008E9, 0.0, 4.0, 551.0] ESTIMATE",
      "id": "[9999.0, 99999.0, 0.0, 8.0, 25988.0] ESTIMATE",
      "shared_clawbacks": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "seller_id": "[-Infinity, Infinity, 0.0, 14.0, 5.0] ESTIMATE",
      "shared_fba_liquidation_proceeds": "[0.0, 54.96, 0.0, 8.0, 170.0] ESTIMATE",
      "shared_liquidations_fees": "[-4.62, 0.0, 0.0, 8.0, 91.0] ESTIMATE",
      "promotional_rebate_refunds": "[0.0, 841.0, 0.0, 8.0, 100.0] ESTIMATE",
      "other_fba_product_sale_refunds": "[-1000.0, 1082.0, 0.0, 8.0, 18.0] ESTIMATE",
      "other_transaction_fees": "[-38.0, 0.0, 0.0, 8.0, 2.0] ESTIMATE",
      "shared_fba_liquidation_proceeds_adjustments": "[-0.75, 0.0, 0.0, 8.0, 22.0] ESTIMATE",
      "mc_fba_fulfillment_fees": "[-1426.0, 0.0, 0.0, 8.0, 30.0] ESTIMATE",
      "chargebacks": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_manual_processing_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shipping_label_purchases": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_shipping_label_purchases": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_amazon_partnered_carrier_shipment_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "reship_fbm_product_sale_refunds": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "fba_customer_return_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "fba_storage_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_safe_t_reimbursement": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "points_adjusted": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_ads_sbv_cost": "[-163.68, 0.0, 0.0, 8.0, 82.0] ESTIMATE",
      "selling_fee_refunds": "[0.0, 821.0, 0.0, 8.0, 299.0] ESTIMATE",
      "shared_netco_transaction": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "ads_sd_cost": "[-57.999495, -0.001846, 0.0, 8.0, 25934.0] ESTIMATE",
      "other_fbm_product_sales": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "promotional_rebates": "[-12666.0, 0.0, 0.0, 8.0, 1444.0] ESTIMATE",
      "shared_commingling_vat_income": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "cost_of_points_granted": "[-428.0, 0.0, 0.0, 8.0, 71.0] ESTIMATE",
      "a_to_z_guarantee_claims": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "company_id": "[9.0111778176883917E17, 9.0111778176883917E17, 0.0, 8.0, 1.0] ESTIMATE",
      "other_fbm_product_sale_refunds": "[-1590.0, 991.0, 0.0, 8.0, 11.0] ESTIMATE",
      "shared_carrier_shipping_label_adjustments": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_labeling_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_customer_return_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_inventory_credit": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_vine_fee": "[-25.73, 0.0, 0.0, 8.0, 157.0] ESTIMATE",
      "shipping_credits": "[0.0, 5568.0, 0.0, 8.0, 1534.0] ESTIMATE",
      "mc_fba_fulfillment_fees_quantity": "[0.0, 2.0, 0.0, 8.0, 3.0] ESTIMATE",
      "fba_transaction_fee_refunds": "[0.0, 510.0, 0.0, 8.0, 67.0] ESTIMATE",
      "ads_sp_cost": "[-54.996795, 0.0, 0.0, 8.0, 25958.0] ESTIMATE",
      "shared_item_fee_adjustment": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_bubblewrap_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "__extend_fields": "[-Infinity, Infinity, 0.0, 655.7073217285082, 7939.0] ESTIMATE",
      "cost_of_points_returned": "[0.0, 19.0, 0.0, 8.0, 5.0] ESTIMATE",
      "reship_fbm_product_sales": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_ads_sb_cost": "[-134.49, 0.0, 0.0, 8.0, 70.0] ESTIMATE",
      "adjustments": "[-52.83, 2.4, 0.0, 8.0, 88.0] ESTIMATE",
      "shared_cash_on_delivery": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "principal_fbm_product_sales": "[0.0, 2164.0, 0.0, 8.0, 48.0] ESTIMATE",
      "shared_fba_inbound_defect_fee": "[-591.02, 0.0, 0.0, 8.0, 9.0] ESTIMATE",
      "shared_adjustments": "[0.0, 923.81, 0.0, 8.0, 63.0] ESTIMATE",
      "fba_inventory_credit": "[0.0, 4363.06, 0.0, 8.0, 328.0] ESTIMATE",
      "shared_fba_international_inbound_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "gift_wrap_credits": "[0.0, 644.0, 0.0, 8.0, 10.0] ESTIMATE",
      "shared_fba_transaction_fee_refunds": "[0.0, 106.93, 0.0, 8.0, 89.0] ESTIMATE",
      "shared_ld_fee": "[-12225.75, 0.0, 0.0, 8.0, 913.0] ESTIMATE",
      "principal_fbm_product_sale_refunds": "[-3816.0, 0.0, 0.0, 8.0, 129.0] ESTIMATE",
      "shared_amazon_shipping_reimbursement": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_overage_fee": "[-1055.75, 0.0, 0.0, 8.0, 10.0] ESTIMATE",
      "long_term_storage_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "country_code": "[-Infinity, Infinity, 0.0, 2.0, 8.0] ESTIMATE",
      "shared_fba_inbound_convenience_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "seller_sku": "[-Infinity, Infinity, 0.0, 23.622690487097266, 371.0] ESTIMATE",
      "shared_other_service_fees": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_others": "[0.0, 10.0, 0.0, 8.0, 907.0] ESTIMATE",
      "shared_long_term_storage_fee": "[-20733.2, 0.0, 0.0, 8.0, 188.0] ESTIMATE",
      "shared_coupon_fee": "[-1859.82, 0.0, 0.0, 8.0, 881.0] ESTIMATE",
      "reship_fba_product_sales": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_early_reviewer_program_fee": "[-20.51, 0.0, 0.0, 8.0, 139.0] ESTIMATE",
      "shared_fba_storage_fee": "[-2055.53, 0.11, 0.0, 8.0, 4146.0] ESTIMATE",
      "other_transaction_fee_refunds": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_fba_inbound_transportation_program_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_subscription_fee": "[-4900.0, 0.0, 0.0, 8.0, 367.0] ESTIMATE",
      "principal_fba_product_sale_refunds": "[-5400.0, 0.0, 0.0, 8.0, 231.0] ESTIMATE",
      "shared_storage_renewal_billing": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "principal_fba_product_sales": "[0.0, 129098.0, 0.0, 8.0, 3686.0] ESTIMATE",
      "other_fba_transaction_fees": "[-33906.0, 0.0, 0.0, 8.0, 3243.0] ESTIMATE",
      "shared_taping_fee": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_other_fba_inventory_fees": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_other_fba_transaction_fees": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "seller_fulfilled_selling_fees": "[-477.0, 0.0, 0.0, 8.0, 49.0] ESTIMATE",
      "gift_wrap_credit_refunds": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "principal_fbm_product_sales_quantity": "[0.0, 10.0, 0.0, 8.0, 11.0] ESTIMATE",
      "shared_reimbursements": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shared_other_fba_product_sales": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "reship_fba_product_sales_quantity": "[0.0, 27.0, 0.0, 8.0, 17.0] ESTIMATE",
      "shipping_credit_refunds": "[-727.0, 0.0, 0.0, 8.0, 107.0] ESTIMATE",
      "fba_returns_quantity": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "shipping_label_refunds": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE",
      "reship_fba_product_sale_refunds": "[0.0, 0.0, 0.0, 8.0, 1.0] ESTIMATE"
    }
  },
  "be_number": 3,
  "be_core_stat": {
    "numOfHardwareCoresPerBe": "{\"32068493\":16,\"32068492\":16,\"32068494\":16}",
    "cachedAvgNumOfHardwareCores": 16
  },
  "exception": [],
  "version": "2.5.9",
  "commit_version": "82f533f"
}